d11_stat_task2

Dataset statistics

Number of variables	19
Number of observations	10027
Missing cells	2577
Missing cells (%)	1.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	152.0 B

Variable types

NUM	17
CAT	2

Warnings

`ID` has a high cardinality: 3123 distinct values	High cardinality
`householdID` has a high cardinality: 6675 distinct values	High cardinality
`wbc` has 230 (2.3%) missing values	Missing
`mcv` has 225 (2.2%) missing values	Missing
`plt` has 227 (2.3%) missing values	Missing
`bun` has 165 (1.6%) missing values	Missing
`glu` has 186 (1.9%) missing values	Missing
`crea` has 189 (1.9%) missing values	Missing
`cho` has 172 (1.7%) missing values	Missing
`tg` has 171 (1.7%) missing values	Missing
`hdl` has 164 (1.6%) missing values	Missing
`ldl` has 182 (1.8%) missing values	Missing
`crp` has 163 (1.6%) missing values	Missing
`hbalc` has 104 (1.0%) missing values	Missing
`ua` has 163 (1.6%) missing values	Missing
`hgb` has 228 (2.3%) missing values	Missing
`householdID` is uniformly distributed	Uniform
`df_index` has unique values	Unique

Reproduction

Analysis started	2020-10-19 07:44:44.171006
Analysis finished	2020-10-19 07:45:29.044177
Duration	44.87 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	10027
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5071.247432
Minimum	0
Maximum	10136
Zeros	1
Zeros (%)	< 0.1%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	508.3
Q1	2528.5
median	5075
Q3	7612.5
95-th percentile	9630.7
Maximum	10136
Range	10136
Interquartile range (IQR)	5084

Descriptive statistics

Standard deviation	2930.336323
Coefficient of variation (CV)	0.577833435
Kurtosis	-1.204010245
Mean	5071.247432
Median Absolute Deviation (MAD)	2542
Skewness	-0.001167268458
Sum	50849398
Variance	8586870.968
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
1346	1	< 0.1%
9550	1	< 0.1%
3403	1	< 0.1%
1354	1	< 0.1%
7497	1	< 0.1%
5448	1	< 0.1%
9542	1	< 0.1%
3395	1	< 0.1%
7489	1	< 0.1%
Other values (10017)	10017	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
10136	1	< 0.1%
10135	1	< 0.1%
10134	1	< 0.1%
10133	1	< 0.1%
10132	1	< 0.1%

ID
Categorical

HIGH CARDINALITY

Distinct	3123
Distinct (%)	31.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

3.26E+11	264
2.66E+11	239
2.96E+11	230
3.30E+11	193
1.08E+11	188
Other values (3118)	8913

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
3.26E+11	264	2.6%
2.66E+11	239	2.4%
2.96E+11	230	2.3%
3.30E+11	193	1.9%
1.08E+11	188	1.9%
2.45E+11	183	1.8%
3.25E+11	173	1.7%
2.07E+11	155	1.5%
2.11E+11	145	1.4%
1.05E+11	145	1.4%
Other values (3113)	8112	80.9%

Frequencies of value counts

Unique

Unique	3041 ?
Unique (%)	30.3%

Histogram of lengths of the category

Length

Max length	11
Median length	8
Mean length	8.909843423
Min length	8

householdID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	6675
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

2982453020	2
101043010	2
1082593060	2
1682311150	2
3211312170	2
Other values (6670)	10017

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2982453020	2	< 0.1%
101043010	2	< 0.1%
1082593060	2	< 0.1%
1682311150	2	< 0.1%
3211312170	2	< 0.1%
2974393190	2	< 0.1%
2660591060	2	< 0.1%
101042220	2	< 0.1%
2660591090	2	< 0.1%
3240451140	2	< 0.1%
Other values (6665)	10007	99.8%

Frequencies of value counts

Unique

Unique	3323 ?
Unique (%)	33.1%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	9.696718859
Min length	9

wbc
Real number (ℝ_≥0)

MISSING

Distinct	574
Distinct (%)	5.9%
Missing	230
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%

Mean	6.24178422
Minimum	3.1
Maximum	12.2
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	3.1
5-th percentile	3.8
Q1	4.99
median	6
Q3	7.2
95-th percentile	9.7
Maximum	12.2
Range	9.1
Interquartile range (IQR)	2.21

Descriptive statistics

Standard deviation	1.813126551
Coefficient of variation (CV)	0.2904820941
Kurtosis	0.7906836293
Mean	6.24178422
Median Absolute Deviation (MAD)	1.1
Skewness	0.8676625076
Sum	61150.76
Variance	3.28742789
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.6	240	2.4%
5.3	226	2.3%
5.5	218	2.2%
6.2	215	2.1%
5.1	215	2.1%
5.9	213	2.1%
5.4	213	2.1%
6.3	210	2.1%
5	207	2.1%
5.8	206	2.1%
Other values (564)	7634	76.1%
(Missing)	230	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.1	121	1.2%
3.12	1	< 0.1%
3.13	2	< 0.1%
3.14	1	< 0.1%
3.15	1	< 0.1%

Value	Count	Frequency (%)
12.2	105	1.0%
12.19	2	< 0.1%
12.1	4	< 0.1%
12	10	0.1%
11.9	4	< 0.1%

mcv
Real number (ℝ_≥0)

MISSING

Distinct	597
Distinct (%)	6.1%
Missing	225
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%

Mean	90.66989186
Minimum	64.4
Maximum	109.8
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	64.4
5-th percentile	73.7
Q1	86.9
median	91.4
Q3	95.7
95-th percentile	102.8
Maximum	109.8
Range	45.4
Interquartile range (IQR)	8.8

Descriptive statistics

Standard deviation	8.21103214
Coefficient of variation (CV)	0.0905596331
Kurtosis	1.188105672
Mean	90.66989186
Median Absolute Deviation (MAD)	4.4
Skewness	-0.7072605261
Sum	888746.28
Variance	67.4210488
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
91	136	1.4%
90	135	1.3%
89	132	1.3%
94	118	1.2%
88	116	1.2%
93	116	1.2%
95	112	1.1%
92	109	1.1%
109.8	101	1.0%
64.6	101	1.0%
Other values (587)	8626	86.0%
(Missing)	225	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
64.4	1	< 0.1%
64.5	2	< 0.1%
64.6	101	1.0%
64.8	1	< 0.1%
64.9	2	< 0.1%

Value	Count	Frequency (%)
109.8	101	1.0%
109.7	4	< 0.1%
109.6	2	< 0.1%
109.52	1	< 0.1%
109.5	2	< 0.1%

plt
Real number (ℝ_≥0)

MISSING

Distinct	342
Distinct (%)	3.5%
Missing	227
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%

Mean	211.9114286
Minimum	71
Maximum	417
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	71
5-th percentile	104
Q1	163
median	208
Q3	255
95-th percentile	333
Maximum	417
Range	346
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	69.59708597
Coefficient of variation (CV)	0.3284253541
Kurtosis	0.1172440802
Mean	211.9114286
Median Absolute Deviation (MAD)	46
Skewness	0.437624346
Sum	2076732
Variance	4843.754375
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
417	104	1.0%
71	103	1.0%
208	71	0.7%
190	70	0.7%
180	69	0.7%
195	67	0.7%
186	67	0.7%
229	67	0.7%
241	67	0.7%
200	65	0.6%
Other values (332)	9050	90.3%
(Missing)	227	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
71	103	1.0%
72	2	< 0.1%
73	4	< 0.1%
74	5	< 0.1%
75	7	0.1%

Value	Count	Frequency (%)
417	104	1.0%
416	3	< 0.1%
415	1	< 0.1%
414	5	< 0.1%
413	2	< 0.1%

bun
Real number (ℝ_≥0)

MISSING

Distinct	744
Distinct (%)	7.5%
Missing	165
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%

Mean	15.67527021
Minimum	7.67474
Maximum	29.46652
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	7.67474
5-th percentile	9.5234
Q1	12.54848
median	15.1254
Q3	18.2065
95-th percentile	23.64044
Maximum	29.46652
Range	21.79178
Interquartile range (IQR)	5.65802

Descriptive statistics

Standard deviation	4.323834515
Coefficient of variation (CV)	0.2758379573
Kurtosis	0.5093365861
Mean	15.67527021
Median Absolute Deviation (MAD)	2.77299
Skewness	0.7227712617
Sum	154589.5148
Variance	18.69554492
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.67474	100	1.0%
29.46652	86	0.9%
15.88167	44	0.4%
14.31311	41	0.4%
13.52883	40	0.4%
14.95734	39	0.4%
16.07774	38	0.4%
12.96863	38	0.4%
15.15341	37	0.4%
15.99371	37	0.4%
Other values (734)	9362	93.4%
(Missing)	165	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7.67474	100	1.0%
7.73076	3	< 0.1%
7.75877	1	< 0.1%
7.78678	1	< 0.1%
7.81479	4	< 0.1%

Value	Count	Frequency (%)
29.46652	86	0.9%
29.38249	1	< 0.1%
29.35448	7	0.1%
29.29846	1	< 0.1%
29.27045	1	< 0.1%

glu
Real number (ℝ_≥0)

MISSING

Distinct	801
Distinct (%)	8.1%
Missing	186
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%

Mean	109.6849507
Minimum	63.9
Maximum	276.12
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	63.9
5-th percentile	82.08
Q1	94.5
median	102.42
Q3	113.76
95-th percentile	165.24
Maximum	276.12
Range	212.22
Interquartile range (IQR)	19.26

Descriptive statistics

Standard deviation	31.02302867
Coefficient of variation (CV)	0.2828376041
Kurtosis	11.86091288
Mean	109.6849507
Median Absolute Deviation (MAD)	9.18
Skewness	3.063208251
Sum	1079409.6
Variance	962.4283079
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
276.12	100	1.0%
63.9	89	0.9%
98.28	71	0.7%
96.48	68	0.7%
100.8	68	0.7%
101.88	66	0.7%
99.72	64	0.6%
101.7	64	0.6%
102.78	63	0.6%
94.5	63	0.6%
Other values (791)	9125	91.0%
(Missing)	186	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
63.9	89	0.9%
64.44	3	< 0.1%
64.62	3	< 0.1%
65.16	2	< 0.1%
65.7	2	< 0.1%

Value	Count	Frequency (%)
276.12	100	1.0%
273.42	2	< 0.1%
272.7	1	< 0.1%
271.98	1	< 0.1%
271.26	3	< 0.1%

crea
Real number (ℝ_≥0)

MISSING

Distinct	84
Distinct (%)	0.9%
Missing	189
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%

Mean	0.7773051535
Minimum	0.4294
Maximum	1.3673
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0.4294
5-th percentile	0.5311
Q1	0.6441
median	0.7571
Q3	0.8814
95-th percentile	1.1074
Maximum	1.3673
Range	0.9379
Interquartile range (IQR)	0.2373

Descriptive statistics

Standard deviation	0.1787702666
Coefficient of variation (CV)	0.2299872397
Kurtosis	0.6906530957
Mean	0.7773051535
Median Absolute Deviation (MAD)	0.113
Skewness	0.7354648268
Sum	7647.1281
Variance	0.03195880824
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7232	295	2.9%
0.7006	282	2.8%
0.6893	281	2.8%
0.7571	277	2.8%
0.7119	276	2.8%
0.6441	270	2.7%
0.678	265	2.6%
0.7684	257	2.6%
0.7797	255	2.5%
0.6667	254	2.5%
Other values (74)	7126	71.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.4294	119	1.2%
0.4407	19	0.2%
0.452	25	0.2%
0.4633	26	0.3%
0.4746	37	0.4%

Value	Count	Frequency (%)
1.3673	105	1.0%
1.356	5	< 0.1%
1.3447	8	0.1%
1.3334	5	< 0.1%
1.3221	5	< 0.1%

cho
Real number (ℝ_≥0)

MISSING

Distinct	473
Distinct (%)	4.8%
Missing	172
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	193.2201301
Minimum	115.98
Maximum	300.7748
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	115.98
5-th percentile	137.243
Q1	167.0112
median	190.2072
Q3	215.3362
95-th percentile	261.7282
Maximum	300.7748
Range	184.7948
Interquartile range (IQR)	48.325

Descriptive statistics

Standard deviation	37.33860855
Coefficient of variation (CV)	0.1932438847
Kurtosis	0.0915980175
Mean	193.2201301
Median Absolute Deviation (MAD)	24.3558
Skewness	0.4758168
Sum	1904184.382
Variance	1394.171689
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300.7748	103	1.0%
115.98	90	0.9%
190.9804	61	0.6%
184.4082	58	0.6%
199.4856	57	0.6%
185.9546	54	0.5%
193.3	54	0.5%
178.9958	53	0.5%
179.3824	52	0.5%
184.0216	50	0.5%
Other values (463)	9223	92.0%
(Missing)	172	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
115.98	90	0.9%
116.3666	3	< 0.1%
116.7532	5	< 0.1%
117.1398	1	< 0.1%
117.5264	2	< 0.1%

Value	Count	Frequency (%)
300.7748	103	1.0%
300.3882	1	< 0.1%
300.0016	2	< 0.1%
299.615	1	< 0.1%
299.2284	1	< 0.1%

tg
Real number (ℝ_≥0)

MISSING

Distinct	488
Distinct (%)	5.0%
Missing	171
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	131.0766173
Minimum	38.055
Maximum	540.735
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	38.055
5-th percentile	49.56
Q1	75.225
median	106.2
Q3	154.875
95-th percentile	304.44
Maximum	540.735
Range	502.68
Interquartile range (IQR)	79.65

Descriptive statistics

Standard deviation	87.05881331
Coefficient of variation (CV)	0.6641826369
Kurtosis	6.306575944
Mean	131.0766173
Median Absolute Deviation (MAD)	36.285
Skewness	2.250136333
Sum	1291891.14
Variance	7579.236975
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.055	110	1.1%
74.34	99	1.0%
540.735	95	0.9%
77.88	89	0.9%
79.65	88	0.9%
80.535	86	0.9%
72.57	86	0.9%
86.73	86	0.9%
85.845	85	0.8%
63.72	84	0.8%
Other values (478)	8948	89.2%
(Missing)	171	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
38.055	110	1.1%
38.94	18	0.2%
39.825	17	0.2%
40.71	21	0.2%
41.595	22	0.2%

Value	Count	Frequency (%)
540.735	95	0.9%
539.85	1	< 0.1%
538.08	1	< 0.1%
533.655	1	< 0.1%
530.115	1	< 0.1%

hdl
Real number (ℝ_≥0)

MISSING

Distinct	194
Distinct (%)	2.0%
Missing	164
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%

Mean	50.94398668
Minimum	22.4228
Maximum	97.0366
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	22.4228
5-th percentile	29.7682
Q1	40.2064
median	49.0982
Q3	59.923
95-th percentile	78.0932
Maximum	97.0366
Range	74.6138
Interquartile range (IQR)	19.7166

Descriptive statistics

Standard deviation	14.82688161
Coefficient of variation (CV)	0.2910428214
Kurtosis	0.3659643037
Mean	50.94398668
Median Absolute Deviation (MAD)	9.665
Skewness	0.6475158664
Sum	502460.5406
Variance	219.8364184
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48.325	130	1.3%
49.0982	126	1.3%
45.6188	122	1.2%
47.9384	120	1.2%
51.8044	115	1.1%
52.191	114	1.1%
45.2322	113	1.1%
47.1652	113	1.1%
44.0724	113	1.1%
44.8456	112	1.1%
Other values (184)	8685	86.6%
(Missing)	164	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
22.4228	106	1.1%
22.8094	7	0.1%
23.196	8	0.1%
23.5826	9	0.1%
23.9692	9	0.1%

Value	Count	Frequency (%)
97.0366	98	1.0%
96.65	7	0.1%
96.2634	2	< 0.1%
95.8768	3	< 0.1%
95.4902	4	< 0.1%

ldl
Real number (ℝ_≥0)

MISSING

Distinct	444
Distinct (%)	4.5%
Missing	182
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%

Mean	116.2473018
Minimum	37.8868
Maximum	210.3104
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	37.8868
5-th percentile	64.5622
Q1	92.784
median	114.047
Q3	136.8564
95-th percentile	177.0628
Maximum	210.3104
Range	172.4236
Interquartile range (IQR)	44.0724

Descriptive statistics

Standard deviation	33.94202347
Coefficient of variation (CV)	0.2919811725
Kurtosis	0.116226154
Mean	116.2473018
Median Absolute Deviation (MAD)	22.0362
Skewness	0.3448181134
Sum	1144454.686
Variance	1152.060957
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210.3104	107	1.1%
37.8868	105	1.0%
112.114	62	0.6%
113.6604	56	0.6%
121.0058	56	0.6%
120.2326	56	0.6%
119.0728	55	0.5%
117.913	55	0.5%
109.4078	54	0.5%
114.8202	54	0.5%
Other values (434)	9185	91.6%
(Missing)	182	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
37.8868	105	1.0%
38.2734	1	< 0.1%
38.66	2	< 0.1%
39.0466	1	< 0.1%
39.4332	1	< 0.1%

Value	Count	Frequency (%)
210.3104	107	1.1%
209.9238	3	< 0.1%
209.1506	4	< 0.1%
208.764	1	< 0.1%
208.3774	2	< 0.1%

crp
Real number (ℝ_≥0)

MISSING

Distinct	1083
Distinct (%)	11.0%
Missing	163
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%

Mean	2.528791565
Minimum	0.19
Maximum	37.02
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0.19
5-th percentile	0.28
Q1	0.55
median	1.04
Q3	2.18
95-th percentile	8.977
Maximum	37.02
Range	36.83
Interquartile range (IQR)	1.63

Descriptive statistics

Standard deviation	5.149011674
Coefficient of variation (CV)	2.036155033
Kurtosis	26.96956375
Mean	2.528791565
Median Absolute Deviation (MAD)	0.6
Skewness	4.93583699
Sum	24944
Variance	26.51232122
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.19	111	1.1%
37.02	100	1.0%
0.45	93	0.9%
0.39	92	0.9%
0.49	86	0.9%
0.47	86	0.9%
0.44	85	0.8%
0.4	82	0.8%
0.35	80	0.8%
0.5	79	0.8%
Other values (1073)	8970	89.5%
(Missing)	163	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.19	111	1.1%
0.2	24	0.2%
0.21	45	0.4%
0.22	37	0.4%
0.23	33	0.3%

Value	Count	Frequency (%)
37.02	100	1.0%
36.7	1	< 0.1%
36.35	1	< 0.1%
36.2	2	< 0.1%
36.1	1	< 0.1%

hbalc
Real number (ℝ_≥0)

MISSING

Distinct	51
Distinct (%)	0.5%
Missing	104
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.252302731
Minimum	4.1
Maximum	9.1
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	4.1
5-th percentile	4.5
Q1	4.9
median	5.1
Q3	5.4
95-th percentile	6.4
Maximum	9.1
Range	5
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.7225145682
Coefficient of variation (CV)	0.1375614859
Kurtosis	10.73604742
Mean	5.252302731
Median Absolute Deviation (MAD)	0.3
Skewness	2.74000154
Sum	52118.6
Variance	0.5220273012
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	957	9.5%
5.1	956	9.5%
5.2	939	9.4%
4.9	869	8.7%
5.3	819	8.2%
4.8	749	7.5%
5.4	682	6.8%
5.5	551	5.5%
4.7	538	5.4%
5.6	379	3.8%
Other values (41)	2484	24.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.1	116	1.2%
4.2	57	0.6%
4.3	91	0.9%
4.4	172	1.7%
4.5	248	2.5%

Value	Count	Frequency (%)
9.1	104	1.0%
9	6	0.1%
8.9	4	< 0.1%
8.8	4	< 0.1%
8.7	6	0.1%

ua
Real number (ℝ_≥0)

MISSING

Distinct	2500
Distinct (%)	25.3%
Missing	163
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%

Mean	4.443844574
Minimum	2.142
Maximum	8.15976
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	2.142
5-th percentile	2.688
Q1	3.56496
median	4.2966
Q3	5.16096
95-th percentile	6.7368
Maximum	8.15976
Range	6.01776
Interquartile range (IQR)	1.596

Descriptive statistics

Standard deviation	1.225451897
Coefficient of variation (CV)	0.2757638968
Kurtosis	0.3011811232
Mean	4.443844574
Median Absolute Deviation (MAD)	0.78204
Skewness	0.6494059102
Sum	43834.08288
Variance	1.501732351
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.142	98	1.0%
8.15976	97	1.0%
4.06896	17	0.2%
4.27896	17	0.2%
4.41504	17	0.2%
4.11264	16	0.2%
4.15128	16	0.2%
4.63176	16	0.2%
3.63552	16	0.2%
4.45536	16	0.2%
Other values (2490)	9538	95.1%
(Missing)	163	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.142	98	1.0%
2.14368	2	< 0.1%
2.14536	1	< 0.1%
2.1504	1	< 0.1%
2.15376	1	< 0.1%

Value	Count	Frequency (%)
8.15976	97	1.0%
8.1564	1	< 0.1%
8.15304	1	< 0.1%
8.14296	1	< 0.1%
8.14128	1	< 0.1%

htc
Real number (ℝ_≥0)

Distinct	581
Distinct (%)	5.8%
Missing	8
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	41.4341072
Minimum	26.77
Maximum	57.6
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	26.77
5-th percentile	30.4
Q1	37.8
median	41.5
Q3	45.2
95-th percentile	51.4
Maximum	57.6
Range	30.83
Interquartile range (IQR)	7.4

Descriptive statistics

Standard deviation	6.014562131
Coefficient of variation (CV)	0.1451596894
Kurtosis	0.1493727421
Mean	41.4341072
Median Absolute Deviation (MAD)	3.7
Skewness	0.0449834957
Sum	415128.32
Variance	36.17495763
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.4	238	2.4%
43	146	1.5%
40	146	1.5%
42	129	1.3%
38	126	1.3%
41	125	1.2%
44	121	1.2%
39	121	1.2%
57.6	112	1.1%
26.77	107	1.1%
Other values (571)	8648	86.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
26.77	107	1.1%
26.8	4	< 0.1%
26.88	1	< 0.1%
26.9	2	< 0.1%
26.93	1	< 0.1%

Value	Count	Frequency (%)
57.6	112	1.1%
57.5	4	< 0.1%
57.45	1	< 0.1%
57.4	3	< 0.1%
57.3	2	< 0.1%

hgb
Real number (ℝ_≥0)

MISSING

Distinct	126
Distinct (%)	1.3%
Missing	228
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%

Mean	14.34178998
Minimum	9.3
Maximum	21.8
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	9.3
5-th percentile	11.3
Q1	13
median	14.2
Q3	15.5
95-th percentile	17.8
Maximum	21.8
Range	12.5
Interquartile range (IQR)	2.5

Descriptive statistics

Standard deviation	2.072490059
Coefficient of variation (CV)	0.1445070707
Kurtosis	1.446860912
Mean	14.34178998
Median Absolute Deviation (MAD)	1.2
Skewness	0.6121117927
Sum	140535.2
Variance	4.295215044
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.2	238	2.4%
13.7	232	2.3%
13.6	227	2.3%
13.9	226	2.3%
13.4	214	2.1%
14.9	213	2.1%
14	211	2.1%
13.1	210	2.1%
14.3	208	2.1%
14.5	206	2.1%
Other values (116)	7614	75.9%
(Missing)	228	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.3	102	1.0%
9.4	9	0.1%
9.5	7	0.1%
9.6	6	0.1%
9.7	9	0.1%

Value	Count	Frequency (%)
21.8	96	1.0%
21.7	6	0.1%
21.6	3	< 0.1%
21.5	6	0.1%
21.4	2	< 0.1%

age
Real number (ℝ_≥0)

Distinct	531
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	59.28314387
Minimum	40
Maximum	85
Zeros	0
Zeros (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	40
5-th percentile	45.916668
Q1	51.833332
median	58.583332
Q3	65.5
95-th percentile	76.5
Maximum	85
Range	45
Interquartile range (IQR)	13.666668

Descriptive statistics

Standard deviation	9.369191874
Coefficient of variation (CV)	0.1580414139
Kurtosis	-0.5344837308
Mean	59.28314387
Median Absolute Deviation (MAD)	6.833332
Skewness	0.3981745467
Sum	594432.0835
Variance	87.78175638
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.916668	54	0.5%
56.666668	51	0.5%
59.75	50	0.5%
57.583332	48	0.5%
58.583332	48	0.5%
56.333332	48	0.5%
62.583332	47	0.5%
48.166668	46	0.5%
60.583332	46	0.5%
48.583332	46	0.5%
Other values (521)	9543	95.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40	2	< 0.1%
40.166668	2	< 0.1%
40.25	2	< 0.1%
40.416668	2	< 0.1%
40.583332	1	< 0.1%

Value	Count	Frequency (%)
85	1	< 0.1%
84.916664	1	< 0.1%
84.833336	3	< 0.1%
84.75	2	< 0.1%
84.583336	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	ID	householdID	wbc	mcv	plt	bun	glu	crea	cho	tg	hdl	ldl	crp	hbalc	ua	htc	hgb	age
0	0	10104101002	101041010	9.6	72.9	198.0	19.43894	95.94	0.9831	254.3828	63.720	63.4024	175.9030	0.98	4.6	3.59520	57.6	20.2	48.166668
1	1	10104102002	101041020	5.3	95.4	179.0	12.35241	94.14	0.8814	205.6712	57.525	61.4694	131.0574	0.34	4.9	5.24664	52.0	17.4	59.916668
2	2	10104104001	101041040	7.5	88.3	271.0	22.09989	105.84	1.1526	168.1710	88.500	47.1652	98.9696	5.67	4.8	4.55952	44.5	14.9	60.833332
3	3	10104105002	101041050	4.7	86.1	208.0	15.62958	87.48	0.6554	219.9754	91.155	46.0054	154.2534	2.47	4.6	3.44736	46.0	16.1	67.666664
4	4	10104107001	101041070	8.3	85.6	290.0	13.22072	95.76	0.9040	168.9442	109.740	40.9796	103.2222	0.76	4.8	5.20128	43.8	14.6	79.333336
5	5	10104108001	101041080	4.6	79.9	294.0	20.02715	89.28	0.6667	217.2692	102.660	49.0982	148.8410	1.17	4.8	3.03408	41.9	13.6	55.833332
6	6	10104108002	101041080	6.3	89.3	228.0	21.98785	103.86	0.8927	209.1506	108.855	49.8714	135.6966	0.45	4.6	3.78000	46.9	16.0	59.583332
7	7	10104109001	101041090	8.7	91.2	278.0	8.31897	94.68	1.0396	151.9338	110.625	43.6858	84.6654	0.64	4.5	5.78928	43.4	14.6	45.333332
8	8	10104110002	101041100	11.4	88.2	417.0	12.88460	118.08	0.5085	172.4236	53.985	51.4178	100.9026	2.71	4.8	2.32512	35.2	12.5	64.666664
9	9	10104111001	101041110	7.9	87.0	285.0	18.31854	96.66	0.6667	127.1914	132.750	56.0570	40.2064	0.57	4.4	4.91064	49.7	17.3	57.000000

Last rows

	df_index	ID	householdID	wbc	mcv	plt	bun	glu	crea	cho	tg	hdl	ldl	crp	hbalc	ua	htc	hgb	age
10017	10127	3.48E+11	3477633020	4.6	79.0	144.0	18.62665	86.58	0.7458	263.6612	59.295	95.8768	156.1864	1.73	4.8	4.28232	NaN	14.4	49.250000
10018	10128	3.48E+11	3477633020	6.6	90.6	80.0	19.94312	96.48	0.9153	230.4136	86.730	41.7528	173.1968	1.24	5.4	4.83840	54.3	20.1	54.166668
10019	10129	3.48E+11	3477633050	5.8	68.9	213.0	11.70818	110.34	0.8136	177.4494	151.335	35.9538	103.2222	3.80	5.1	5.05008	34.3	11.9	59.583332
10020	10130	3.48E+11	3477633050	8.3	87.8	197.0	15.65759	108.00	0.9718	178.6092	92.925	37.8868	122.9388	8.36	5.5	5.23152	45.8	16.5	67.333336
10021	10131	3.48E+11	3477633070	8.5	88.7	263.0	12.12833	106.56	0.7232	171.2638	64.605	40.5930	117.1398	5.05	5.9	4.66872	44.3	16.6	48.250000
10022	10132	3.48E+11	3477633070	5.4	88.3	179.0	12.46445	94.68	0.9379	176.6762	75.225	35.5672	127.5780	2.56	5.5	5.64984	41.2	17.5	49.750000
10023	10133	3.48E+11	3477633100	4.9	97.2	136.0	18.71068	112.86	1.1865	186.7278	194.700	27.0620	116.3666	1.52	5.9	6.58392	36.7	13.6	71.333336
10024	10134	3.48E+11	3477633100	4.8	84.4	197.0	12.71654	98.46	0.8927	192.9134	109.740	47.1652	120.2326	0.70	5.2	3.56496	42.8	15.9	61.250000
10025	10135	3.48E+11	3477633120	5.6	90.7	120.0	17.03008	107.82	0.8362	238.9188	149.565	38.2734	158.1194	0.90	5.1	4.55952	41.6	16.1	48.583332
10026	10136	3.48E+11	3477633120	7.7	98.3	157.0	18.82272	104.40	0.9153	180.5422	54.870	57.9900	105.5418	1.77	5.6	4.95264	46.6	17.7	53.833332

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows